var orderSql = {
  insertCusOrder: 'INSERT INTO wx_cusorders(ORDERID, CUSID, ORDERTIME, ORDERSTATE, ORDERTOTLEPRICE) VALUES(?, ?, ?, ?, ?)',
  insertOrderDetail: 'INSERT INTO wx_orderdetail(GID, ORDERID, GNAME, GCOUNT, GPRICE, GTIME) VALUES(?, ?, ?, ?, ?, ?)',
  insertOverOrder: 'INSERT INTO wx_overorder(ORDERID, CUSID, ORDERTIME, ORDERSTATE, ORDERTOTLEPRICE) VALUES(?, ?, ?, ?, ?)',
  queryAllCusOrder: 'SELECT * FROM wx_cusorders',
  queryAllOrderDetail: 'SELECT * FROM wx_orderdetail',
  queryAllOverOrder: 'SELECT * FROM wx_overorder',
  selectCusOrder: 'SELECT * FROM wx_cusorders WHERE CUSID=',
  selectCusOrderOrderId: 'SELECT * FROM wx_cusorders WHERE ORDERID=',
  selectOrderDetail: 'SELECT * FROM wx_orderdetail WHERE ORDERID=',
  deleteCusOrder: 'DELETE FROM wx_cusorders WHERE ORDERID=',

  queryOverOrderById: 'SELECT * FROM wx_overorder WHERE ORDERID=',
  queryOverOrderByORDERNUM: 'SELECT * FROM wx_overorder WHERE ORDERNUM='
}

module.exports = orderSql